
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<%@ taglib prefix="sql" uri="http://java.sun.com/jsp/jstl/sql" %>

<%@page import="java.util.List"%>
<%@page contentType="text/html" pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
    <head>
        <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
        <link rel="stylesheet" href="css/bootstrap.min.css"/>
        <link rel="stylesheet" href="css/style.css"/>
        <script src="js/jquery-3.4.1.min.js"></script>
        <script src="js/bootstrap.min.js"></script>
        <script src="js/script.js" charset="UTF-8"></script>

        <link rel="stylesheet" type="text/css" href="css/default.css">
        <link rel="stylesheet" href="http://fonts.googleapis.com/css?family=Roboto:300,700">
        <link rel="stylesheet" href="css/style.min.css">
        <!--<link rel="stylesheet" href="css/bootstrap.min.css"/>-->
        <link rel="stylesheet" href="css/mystyle.css"/>
        <script src="js/jquery-3.4.1.js"></script>	
        <!--<script src="js/bootstrap.min.js"> </script>-->
        <!-- 最新版本的 Bootstrap 核心 CSS 文件 -->
        <link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/bootstrap@3.3.7/dist/css/bootstrap.min.css" integrity="sha384-BVYiiSIFeK1dGmJRAkycuHAHRg32OmUcww7on3RYdg4Va+PmSTsz/K68vbdEjh4u" crossorigin="anonymous">
        <!-- 最新的 Bootstrap 核心 JavaScript 文件 -->
        <script src="https://cdn.jsdelivr.net/npm/bootstrap@3.3.7/dist/js/bootstrap.min.js" integrity="sha384-Tc5IQib027qvyjSMfHjOMaLkfuWVxZxUPnCJA7l2mCWNIpG9mGCD8wGNIcPD7Txa" crossorigin="anonymous"></script>
        <title>所有日志</title>

        <style type="text/css">
            #div1{text-align: center;width: 400px;height: 40px; padding-left: 50px;padding-right: 5px;position: absolute;left: 730px}
        </style>
    </head>
    <body>


        <!--------------------------上部菜单栏------------------------------>    
        <div style="position: relative;left: 880px;display: none" >
            <nav class="class="navbar navbar-default navbar-fixed-top"" >
                 <div class="container"  >
                    <!-- Brand and toggle get grouped for better mobile display -->
                    <div class="navbar-header">
                        <button type="button" class="navbar-toggle collapsed" data-toggle="collapse" data-target="#bs-example-navbar-collapse-1" aria-expanded="false">
                            <span class="sr-only">Toggle navigation</span>
                            <span class="icon-bar"></span>
                            <span class="icon-bar"></span>
                            <span class="icon-bar"></span>
                        </button>
                        <a class="navbar-brand" href="login.html" style=" font-family:黑体" >注销</a>
                    </div>

                    <!-- Collect the nav links, forms, and other content for toggling -->
                    <div class="collapse navbar-collapse" id="bs-example-navbar-collapse-1" >
                        <ul class="nav navbar-nav">
                            
                            <li><a href="AllActivity.jsp" style=" font-family:黑体">所有活动</a></li>
                            <li class="dropdown">
                                <a href="#" class="dropdown-toggle" data-toggle="dropdown" role="button" aria-haspopup="true" aria-expanded="false" style="font-family:'黑体'">其他选项 <span class="caret"></span></a>
                                <ul class="dropdown-menu">
                                    <li><a href="#">Action</a></li>
                                    <li><a href="#">Another action</a></li>
                                    <li><a href="#">Something else here</a></li>
                                    <li role="separator" class="divider"></li>
                                    <li><a href="#">Separated link</a></li>
                                    <li role="separator" class="divider"></li>
                                    <li><a href="#">退出登陆</a></li>
                                </ul>
                            </li>
                        </ul>
                       

                        <ul class="nav navbar-nav navbar-right">
                            <li><a href="#">Link</a></li>
                            <li class="dropdown">
                                <a href="#" class="dropdown-toggle" data-toggle="dropdown" role="button" aria-haspopup="true" aria-expanded="false">Dropdown <span class="caret"></span></a>
                                <ul class="dropdown-menu">
                                    <li><a href="#">Action</a></li>
                                    <li><a href="#">Another action</a></li>
                                    <li><a href="#">Something else here</a></li>
                                    <li role="separator" class="divider"></li>
                                    <li><a href="#">Separated link</a></li>
                                </ul>
                            </li>
                        </ul>
                    </div><!-- /.navbar-collapse -->
                </div><!-- /.container-fluid -->
            </nav>    
        </div>  
        
        
        
        
        
        
        
        <form class="navbar-form navbar-left" name="searchnote_form" method="post" action="ooo" style="position: absolute ;right: 100px">
                          <input type="text" name="Ntopic" class="form-control" placeholder="请输入发布的主题关键字">
                          <button id="btn_searchnote" type="submit" class="btn btn-default" >搜索日志</button>
        </form>


        <!---------------------------------标头---------------------------->
        <div class="page-header">
            <img src="img/19081068d0dc8bcc4447246548cab615.png" style="float:left; position:absolute;top:28px">
            <h1 class="head1">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
                公益网 <small class="head2"><i>阳光、雨露、雪中炭；真爱、慈善、人间情。</i></small></h1>
        </div>




        <!---------------------------------内容---------------------------->




        <sql:setDataSource  driver="com.microsoft.sqlserver.jdbc.SQLServerDriver" 
                            url="jdbc:sqlserver://localhost:1433;databaseName=PA"
                            user="sa"
                            password="sa" 
                            var="ds" 
                            scope="session" />
<!--dataSource数据库连接使用-->
        <sql:query dataSource="${ds}" var="rs" scope="page">
            select * from Note order by Uno offset 0 rows fetch next 10 rows only
        </sql:query>




        <h2 class="text-info  text-center">所有日志</h2>
        <div id="div1" class="panel-default">

            <c:forEach items="${rs.rows}" var="row">

                <div>
                    <a target="_blank" href="hhh?Nno=${row.Nno}" style="text-decoration:none ">
                        <table class="table text-center" style="color: black ;border: 2px solid red;background-color: white">
                        <tr >
                            <td>发布用户编号：</td>
                            <td>${row.Uno}</td>
                        </tr>
                         <tr >
                            <td>发布用户名：</td>
                            <td>${row.Uname}</td>
                        </tr>               
                        <tr >
                            <td>发布时间：</td>
                            <td>${row.Nst}</td>
                        </tr>
                        <tr>
                            <td>发布主题：</td>
                            <td>${row.Ntopic}</td>
                        </tr>
                        <br><br>
                    </table>
                    </a>
             </div>
                </c:forEach>
        </div>









    </body>
</html>
